CREATE TABLE [dbo].[Rpt_ProductInventory]
(
[PTRANS_NUMBER] [int] NULL,
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Rpt_ProductInventory_PRODUCT_CODE] DEFAULT (''),
[DESCRIPTION] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TRANS_GROUP_NUMBER] [int] NULL,
[PO_REFERENCE_NUMBER] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TRANSACTION_DATE] [datetime] NULL,
[QUANTITY] [float] NULL,
[UNIT_COST] [numeric] (15, 2) NULL,
[TOTAL_AMOUNT] [numeric] (15, 2) NULL,
[FROM_LOCATION] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FROM_BIN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TO_LOCATION] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TO_BIN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TRANSACTION_TYPE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TITLE] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ORDER_NUMBER] [float] NULL,
[BT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FULL_NAME] [varchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ORDER_DATE] [datetime] NULL,
[ORDER_TYPE_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FLAG] [tinyint] NULL,
[UserId_Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BACKORDERED] [float] NULL,
[STAGE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PRODUCT_STATUS] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
GRANT REFERENCES ON  [dbo].[Rpt_ProductInventory] TO [IMIS]
GRANT SELECT ON  [dbo].[Rpt_ProductInventory] TO [IMIS]
GRANT INSERT ON  [dbo].[Rpt_ProductInventory] TO [IMIS]
GRANT DELETE ON  [dbo].[Rpt_ProductInventory] TO [IMIS]
GRANT UPDATE ON  [dbo].[Rpt_ProductInventory] TO [IMIS]
GO